USE [NLKHCNData]
print 'Update view DeTaiCapNhaNuocView'
GO

ALTER VIEW [dbo].[DeTaiCapNhaNuocView]
AS
SELECT        dbo.DeTaiCapNhaNuoc.TenDeTai, dbo.ChuyenNganh.Ten AS TenChuyenNganh, dbo.LinhVuc.Ten AS TenLinhVuc, dbo.DeTaiCapNhaNuoc.NamThucHien, 
                         dbo.DeTaiCapNhaNuoc.TacGia, dbo.DeTaiCapNhaNuoc.ChuyenGiaId
FROM            dbo.DeTaiCapNhaNuoc LEFT OUTER JOIN
                         dbo.ChuyenNganh ON dbo.ChuyenNganh.Id = dbo.DeTaiCapNhaNuoc.ChuyenNganhId LEFT OUTER JOIN
                         dbo.LinhVuc ON dbo.LinhVuc.Id = dbo.DeTaiCapNhaNuoc.LinhVucId

GO


